/*
 Navicat Premium Data Transfer

 Source Server         : localhostDB
 Source Server Type    : MySQL
 Source Server Version : 80016
 Source Host           : localhost:3306
 Source Schema         : CubeLibrary

 Target Server Type    : MySQL
 Target Server Version : 80016
 File Encoding         : 65001

 Date: 15/11/2019 13:42:31
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for Administrator
-- ----------------------------
DROP TABLE IF EXISTS `Administrator`;
CREATE TABLE `Administrator` (
  `AdminiNumber` varchar(32) NOT NULL COMMENT '自动编号',
  `Name` varchar(32) NOT NULL COMMENT '姓名',
  `IDNumber` varchar(18) NOT NULL COMMENT '身份证号',
  `Password` varchar(32) NOT NULL COMMENT '密码',
  `AdminiRep` varchar(32) NOT NULL COMMENT '管理库',
  PRIMARY KEY (`IDNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='管理员';

-- ----------------------------
-- Records of Administrator
-- ----------------------------
BEGIN;
INSERT INTO `Administrator` VALUES ('A75-0', '张健强', '511521199807076171', '123', '75-0-A');
COMMIT;

-- ----------------------------
-- Table structure for BookingWarehousing
-- ----------------------------
DROP TABLE IF EXISTS `BookingWarehousing`;
CREATE TABLE `BookingWarehousing` (
  `Name` varchar(32) NOT NULL COMMENT '姓名',
  `IDNumber` varchar(18) NOT NULL COMMENT '身份证号',
  `LicensePlateNumber` varchar(32) NOT NULL COMMENT '车牌号',
  `BookingTime` datetime NOT NULL COMMENT '预约时间',
  `MemberGrade` int(11) NOT NULL COMMENT '会员等级',
  `WaitingTime` int(11) NOT NULL COMMENT '等待时间',
  `BookingParking` varchar(32) NOT NULL COMMENT '预约车位',
  `TradeNo` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单号',
  `Status` int(11) NOT NULL COMMENT '入库状态 1入库 0未入库',
  `Address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '立方库地址',
  PRIMARY KEY (`TradeNo`) USING BTREE,
  UNIQUE KEY `TradeNo` (`TradeNo`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='预约入库';

-- ----------------------------
-- Records of BookingWarehousing
-- ----------------------------
BEGIN;
INSERT INTO `BookingWarehousing` VALUES ('张健强', '511521199807076171', '京ALJ183', '2019-11-14 17:57:43', 1, 20, '75-0-A-1-1', '2ca41dc732671df623e18387debf5bcc', 2, '成都市203号');
INSERT INTO `BookingWarehousing` VALUES ('张健强', '511521199807076171', '甘E66666', '2019-11-14 17:58:42', 1, 20, '75-0-A-1-1', '9c17ef9db379a0f15292b3ba7171881d', 2, '成都市203号');
COMMIT;

-- ----------------------------
-- Table structure for cityCode
-- ----------------------------
DROP TABLE IF EXISTS `cityCode`;
CREATE TABLE `cityCode` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `citycode` int(11) DEFAULT NULL COMMENT '城市代码',
  `city` varchar(100) DEFAULT NULL COMMENT '城市名称',
  `initial` char(1) DEFAULT NULL COMMENT '城市首字母',
  PRIMARY KEY (`id`),
  KEY `city` (`city`),
  KEY `citycode` (`citycode`)
) ENGINE=InnoDB AUTO_INCREMENT=389 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='全国城市代码';

-- ----------------------------
-- Records of cityCode
-- ----------------------------
BEGIN;
INSERT INTO `cityCode` VALUES (1, 33, '嘉峪关市', 'J');
INSERT INTO `cityCode` VALUES (2, 34, '金昌市', 'J');
INSERT INTO `cityCode` VALUES (3, 35, '白银市', 'B');
INSERT INTO `cityCode` VALUES (4, 36, '兰州市', 'L');
INSERT INTO `cityCode` VALUES (5, 37, '酒泉市', 'J');
INSERT INTO `cityCode` VALUES (6, 38, '大兴安岭地区', 'D');
INSERT INTO `cityCode` VALUES (7, 39, '黑河市', 'H');
INSERT INTO `cityCode` VALUES (8, 40, '伊春市', 'Y');
INSERT INTO `cityCode` VALUES (9, 41, '齐齐哈尔市', 'Q');
INSERT INTO `cityCode` VALUES (10, 42, '佳木斯市', 'J');
INSERT INTO `cityCode` VALUES (11, 43, '鹤岗市', 'H');
INSERT INTO `cityCode` VALUES (12, 44, '绥化市', 'S');
INSERT INTO `cityCode` VALUES (13, 45, '双鸭山市', 'S');
INSERT INTO `cityCode` VALUES (14, 46, '鸡西市', 'J');
INSERT INTO `cityCode` VALUES (15, 47, '七台河市', 'Q');
INSERT INTO `cityCode` VALUES (16, 48, '哈尔滨市', 'H');
INSERT INTO `cityCode` VALUES (17, 49, '牡丹江市', 'M');
INSERT INTO `cityCode` VALUES (18, 50, '大庆市', 'D');
INSERT INTO `cityCode` VALUES (19, 51, '白城市', 'B');
INSERT INTO `cityCode` VALUES (20, 52, '松原市', 'S');
INSERT INTO `cityCode` VALUES (21, 53, '长春市', 'C');
INSERT INTO `cityCode` VALUES (22, 54, '延边朝鲜族自治州', 'Y');
INSERT INTO `cityCode` VALUES (23, 55, '吉林市', 'J');
INSERT INTO `cityCode` VALUES (24, 56, '四平市', 'S');
INSERT INTO `cityCode` VALUES (25, 57, '白山市', 'B');
INSERT INTO `cityCode` VALUES (26, 58, '沈阳市', 'S');
INSERT INTO `cityCode` VALUES (27, 59, '阜新市', 'F');
INSERT INTO `cityCode` VALUES (28, 60, '铁岭市', 'T');
INSERT INTO `cityCode` VALUES (29, 61, '呼伦贝尔市', 'H');
INSERT INTO `cityCode` VALUES (30, 62, '兴安盟', 'X');
INSERT INTO `cityCode` VALUES (31, 63, '锡林郭勒盟', 'X');
INSERT INTO `cityCode` VALUES (32, 64, '通辽市', 'T');
INSERT INTO `cityCode` VALUES (33, 65, '海西蒙古族藏族自治州', 'H');
INSERT INTO `cityCode` VALUES (34, 66, '西宁市', 'X');
INSERT INTO `cityCode` VALUES (35, 67, '海北藏族自治州', 'H');
INSERT INTO `cityCode` VALUES (36, 68, '海南藏族自治州', 'H');
INSERT INTO `cityCode` VALUES (37, 69, '海东地区', 'H');
INSERT INTO `cityCode` VALUES (38, 70, '黄南藏族自治州', 'H');
INSERT INTO `cityCode` VALUES (39, 71, '玉树藏族自治州', 'Y');
INSERT INTO `cityCode` VALUES (40, 72, '果洛藏族自治州', 'G');
INSERT INTO `cityCode` VALUES (41, 73, '甘孜藏族自治州', 'G');
INSERT INTO `cityCode` VALUES (42, 74, '德阳市', 'D');
INSERT INTO `cityCode` VALUES (43, 75, '成都市', 'C');
INSERT INTO `cityCode` VALUES (44, 76, '雅安市', 'Y');
INSERT INTO `cityCode` VALUES (45, 77, '眉山市', 'M');
INSERT INTO `cityCode` VALUES (46, 78, '自贡市', 'Z');
INSERT INTO `cityCode` VALUES (47, 79, '乐山市', 'L');
INSERT INTO `cityCode` VALUES (48, 80, '凉山彝族自治州', 'L');
INSERT INTO `cityCode` VALUES (49, 81, '攀枝花市', 'P');
INSERT INTO `cityCode` VALUES (50, 82, '和田地区', 'H');
INSERT INTO `cityCode` VALUES (51, 83, '喀什地区', 'K');
INSERT INTO `cityCode` VALUES (52, 84, '克孜勒苏柯尔克孜自治州', 'K');
INSERT INTO `cityCode` VALUES (53, 85, '阿克苏地区', 'A');
INSERT INTO `cityCode` VALUES (54, 86, '巴音郭楞蒙古自治州', 'B');
INSERT INTO `cityCode` VALUES (55, 88, '博尔塔拉蒙古自治州', 'B');
INSERT INTO `cityCode` VALUES (56, 89, '吐鲁番地区', 'T');
INSERT INTO `cityCode` VALUES (57, 90, '伊犁哈萨克自治州', 'Y');
INSERT INTO `cityCode` VALUES (58, 91, '哈密地区', 'H');
INSERT INTO `cityCode` VALUES (59, 92, '乌鲁木齐市', 'W');
INSERT INTO `cityCode` VALUES (60, 93, '昌吉回族自治州', 'C');
INSERT INTO `cityCode` VALUES (61, 94, '塔城地区', 'T');
INSERT INTO `cityCode` VALUES (62, 95, '克拉玛依市', 'K');
INSERT INTO `cityCode` VALUES (63, 96, '阿勒泰地区', 'A');
INSERT INTO `cityCode` VALUES (64, 97, '山南地区', 'S');
INSERT INTO `cityCode` VALUES (65, 98, '林芝地区', 'L');
INSERT INTO `cityCode` VALUES (66, 99, '昌都地区', 'C');
INSERT INTO `cityCode` VALUES (67, 100, '拉萨市', 'L');
INSERT INTO `cityCode` VALUES (68, 101, '那曲地区', 'N');
INSERT INTO `cityCode` VALUES (69, 102, '日喀则地区', 'R');
INSERT INTO `cityCode` VALUES (70, 103, '阿里地区', 'A');
INSERT INTO `cityCode` VALUES (71, 104, '昆明市', 'K');
INSERT INTO `cityCode` VALUES (72, 105, '楚雄彝族自治州', 'C');
INSERT INTO `cityCode` VALUES (73, 106, '玉溪市', 'Y');
INSERT INTO `cityCode` VALUES (74, 107, '红河哈尼族彝族自治州', 'H');
INSERT INTO `cityCode` VALUES (75, 108, '普洱市', 'P');
INSERT INTO `cityCode` VALUES (76, 109, '西双版纳傣族自治州', 'X');
INSERT INTO `cityCode` VALUES (77, 110, '临沧市', 'L');
INSERT INTO `cityCode` VALUES (78, 111, '大理白族自治州', 'D');
INSERT INTO `cityCode` VALUES (79, 112, '保山市', 'B');
INSERT INTO `cityCode` VALUES (80, 113, '怒江傈僳族自治州', 'N');
INSERT INTO `cityCode` VALUES (81, 114, '丽江市', 'L');
INSERT INTO `cityCode` VALUES (82, 115, '迪庆藏族自治州', 'D');
INSERT INTO `cityCode` VALUES (83, 116, '德宏傣族景颇族自治州', 'D');
INSERT INTO `cityCode` VALUES (84, 117, '张掖市', 'Z');
INSERT INTO `cityCode` VALUES (85, 118, '武威市', 'W');
INSERT INTO `cityCode` VALUES (86, 119, '东莞市', 'D');
INSERT INTO `cityCode` VALUES (87, 120, '东沙群岛', 'D');
INSERT INTO `cityCode` VALUES (88, 121, '三亚市', 'S');
INSERT INTO `cityCode` VALUES (89, 122, '鄂州市', 'E');
INSERT INTO `cityCode` VALUES (90, 123, '乌海市', 'W');
INSERT INTO `cityCode` VALUES (91, 124, '莱芜市', 'L');
INSERT INTO `cityCode` VALUES (92, 125, '海口市', 'H');
INSERT INTO `cityCode` VALUES (93, 126, '蚌埠市', 'B');
INSERT INTO `cityCode` VALUES (94, 127, '合肥市', 'H');
INSERT INTO `cityCode` VALUES (95, 128, '阜阳市', 'F');
INSERT INTO `cityCode` VALUES (96, 129, '芜湖市', 'W');
INSERT INTO `cityCode` VALUES (97, 130, '安庆市', 'A');
INSERT INTO `cityCode` VALUES (98, 131, '北京市', 'B');
INSERT INTO `cityCode` VALUES (99, 132, '重庆市', 'Z');
INSERT INTO `cityCode` VALUES (100, 133, '南平市', 'N');
INSERT INTO `cityCode` VALUES (101, 134, '泉州市', 'Q');
INSERT INTO `cityCode` VALUES (102, 135, '庆阳市', 'Q');
INSERT INTO `cityCode` VALUES (103, 136, '定西市', 'D');
INSERT INTO `cityCode` VALUES (104, 137, '韶关市', 'S');
INSERT INTO `cityCode` VALUES (105, 138, '佛山市', 'F');
INSERT INTO `cityCode` VALUES (106, 139, '茂名市', 'M');
INSERT INTO `cityCode` VALUES (107, 140, '珠海市', 'Z');
INSERT INTO `cityCode` VALUES (108, 141, '梅州市', 'M');
INSERT INTO `cityCode` VALUES (109, 142, '桂林市', 'G');
INSERT INTO `cityCode` VALUES (110, 143, '河池市', 'H');
INSERT INTO `cityCode` VALUES (111, 144, '崇左市', 'C');
INSERT INTO `cityCode` VALUES (112, 145, '钦州市', 'Q');
INSERT INTO `cityCode` VALUES (113, 146, '贵阳市', 'G');
INSERT INTO `cityCode` VALUES (114, 147, '六盘水市', 'L');
INSERT INTO `cityCode` VALUES (115, 148, '秦皇岛市', 'Q');
INSERT INTO `cityCode` VALUES (116, 149, '沧州市', 'C');
INSERT INTO `cityCode` VALUES (117, 150, '石家庄市', 'S');
INSERT INTO `cityCode` VALUES (118, 151, '邯郸市', 'H');
INSERT INTO `cityCode` VALUES (119, 152, '新乡市', 'X');
INSERT INTO `cityCode` VALUES (120, 153, '洛阳市', 'L');
INSERT INTO `cityCode` VALUES (121, 154, '商丘市', 'S');
INSERT INTO `cityCode` VALUES (122, 155, '许昌市', 'X');
INSERT INTO `cityCode` VALUES (123, 156, '襄阳市', 'X');
INSERT INTO `cityCode` VALUES (124, 157, '荆州市', 'J');
INSERT INTO `cityCode` VALUES (125, 158, '长沙市', 'C');
INSERT INTO `cityCode` VALUES (126, 159, '衡阳市', 'H');
INSERT INTO `cityCode` VALUES (127, 160, '镇江市', 'Z');
INSERT INTO `cityCode` VALUES (128, 161, '南通市', 'N');
INSERT INTO `cityCode` VALUES (129, 162, '淮安市', 'H');
INSERT INTO `cityCode` VALUES (130, 163, '南昌市', 'N');
INSERT INTO `cityCode` VALUES (131, 164, '新余市', 'X');
INSERT INTO `cityCode` VALUES (132, 165, '通化市', 'T');
INSERT INTO `cityCode` VALUES (133, 166, '锦州市', 'J');
INSERT INTO `cityCode` VALUES (134, 167, '大连市', 'D');
INSERT INTO `cityCode` VALUES (135, 168, '乌兰察布市', 'W');
INSERT INTO `cityCode` VALUES (136, 169, '巴彦淖尔市', 'B');
INSERT INTO `cityCode` VALUES (137, 170, '渭南市', 'W');
INSERT INTO `cityCode` VALUES (138, 171, '宝鸡市', 'B');
INSERT INTO `cityCode` VALUES (139, 172, '枣庄市', 'Z');
INSERT INTO `cityCode` VALUES (140, 173, '日照市', 'R');
INSERT INTO `cityCode` VALUES (141, 174, '东营市', 'D');
INSERT INTO `cityCode` VALUES (142, 175, '威海市', 'W');
INSERT INTO `cityCode` VALUES (143, 176, '太原市', 'T');
INSERT INTO `cityCode` VALUES (144, 177, '文山壮族苗族自治州', 'W');
INSERT INTO `cityCode` VALUES (145, 178, '温州市', 'W');
INSERT INTO `cityCode` VALUES (146, 179, '杭州市', 'H');
INSERT INTO `cityCode` VALUES (147, 180, '宁波市', 'N');
INSERT INTO `cityCode` VALUES (148, 181, '中卫市', 'Z');
INSERT INTO `cityCode` VALUES (149, 182, '临夏回族自治州', 'L');
INSERT INTO `cityCode` VALUES (150, 183, '辽源市', 'L');
INSERT INTO `cityCode` VALUES (151, 184, '抚顺市', 'F');
INSERT INTO `cityCode` VALUES (152, 185, '阿坝藏族羌族自治州', 'A');
INSERT INTO `cityCode` VALUES (153, 186, '宜宾市', 'Y');
INSERT INTO `cityCode` VALUES (154, 187, '中山市', 'Z');
INSERT INTO `cityCode` VALUES (155, 188, '亳州市', NULL);
INSERT INTO `cityCode` VALUES (156, 189, '滁州市', 'C');
INSERT INTO `cityCode` VALUES (157, 190, '宣城市', 'X');
INSERT INTO `cityCode` VALUES (158, 191, '廊坊市', 'L');
INSERT INTO `cityCode` VALUES (159, 192, '宁德市', 'N');
INSERT INTO `cityCode` VALUES (160, 193, '龙岩市', 'L');
INSERT INTO `cityCode` VALUES (161, 194, '厦门市', 'X');
INSERT INTO `cityCode` VALUES (162, 195, '莆田市', 'P');
INSERT INTO `cityCode` VALUES (163, 196, '天水市', 'T');
INSERT INTO `cityCode` VALUES (164, 197, '清远市', 'Q');
INSERT INTO `cityCode` VALUES (165, 198, '湛江市', 'Z');
INSERT INTO `cityCode` VALUES (166, 199, '阳江市', 'Y');
INSERT INTO `cityCode` VALUES (167, 200, '河源市', 'H');
INSERT INTO `cityCode` VALUES (168, 201, '潮州市', 'C');
INSERT INTO `cityCode` VALUES (169, 202, '来宾市', 'L');
INSERT INTO `cityCode` VALUES (170, 203, '百色市', 'B');
INSERT INTO `cityCode` VALUES (171, 204, '防城港市', 'F');
INSERT INTO `cityCode` VALUES (172, 205, '铜仁地区', 'T');
INSERT INTO `cityCode` VALUES (173, 206, '毕节地区', 'B');
INSERT INTO `cityCode` VALUES (174, 207, '承德市', 'C');
INSERT INTO `cityCode` VALUES (175, 208, '衡水市', 'H');
INSERT INTO `cityCode` VALUES (176, 209, '濮阳市', NULL);
INSERT INTO `cityCode` VALUES (177, 210, '开封市', 'K');
INSERT INTO `cityCode` VALUES (178, 211, '焦作市', 'J');
INSERT INTO `cityCode` VALUES (179, 212, '三门峡市', 'S');
INSERT INTO `cityCode` VALUES (180, 213, '平顶山市', 'P');
INSERT INTO `cityCode` VALUES (181, 214, '信阳市', 'X');
INSERT INTO `cityCode` VALUES (182, 215, '鹤壁市', 'H');
INSERT INTO `cityCode` VALUES (183, 216, '十堰市', 'S');
INSERT INTO `cityCode` VALUES (184, 217, '荆门市', 'J');
INSERT INTO `cityCode` VALUES (185, 218, '武汉市', 'W');
INSERT INTO `cityCode` VALUES (186, 219, '常德市', 'C');
INSERT INTO `cityCode` VALUES (187, 220, '岳阳市', 'Y');
INSERT INTO `cityCode` VALUES (188, 221, '娄底市', 'L');
INSERT INTO `cityCode` VALUES (189, 222, '株洲市', 'Z');
INSERT INTO `cityCode` VALUES (190, 223, '盐城市', 'Y');
INSERT INTO `cityCode` VALUES (191, 224, '苏州市', 'S');
INSERT INTO `cityCode` VALUES (192, 225, '景德镇市', 'J');
INSERT INTO `cityCode` VALUES (193, 226, '抚州市', 'F');
INSERT INTO `cityCode` VALUES (194, 227, '本溪市', 'B');
INSERT INTO `cityCode` VALUES (195, 228, '盘锦市', 'P');
INSERT INTO `cityCode` VALUES (196, 229, '包头市', 'B');
INSERT INTO `cityCode` VALUES (197, 230, '阿拉善盟', 'A');
INSERT INTO `cityCode` VALUES (198, 231, '榆林市', 'Y');
INSERT INTO `cityCode` VALUES (199, 232, '铜川市', 'T');
INSERT INTO `cityCode` VALUES (200, 233, '西安市', 'X');
INSERT INTO `cityCode` VALUES (201, 234, '临沂市', 'L');
INSERT INTO `cityCode` VALUES (202, 235, '滨州市', 'B');
INSERT INTO `cityCode` VALUES (203, 236, '青岛市', 'Q');
INSERT INTO `cityCode` VALUES (204, 237, '朔州市', 'S');
INSERT INTO `cityCode` VALUES (205, 238, '晋中市', 'J');
INSERT INTO `cityCode` VALUES (206, 239, '巴中市', 'B');
INSERT INTO `cityCode` VALUES (207, 240, '绵阳市', 'M');
INSERT INTO `cityCode` VALUES (208, 241, '广安市', 'G');
INSERT INTO `cityCode` VALUES (209, 242, '资阳市', 'Z');
INSERT INTO `cityCode` VALUES (210, 243, '衢州市', NULL);
INSERT INTO `cityCode` VALUES (211, 244, '台州市', 'T');
INSERT INTO `cityCode` VALUES (212, 245, '舟山市', 'Z');
INSERT INTO `cityCode` VALUES (213, 246, '固原市', 'G');
INSERT INTO `cityCode` VALUES (214, 247, '甘南藏族自治州', 'G');
INSERT INTO `cityCode` VALUES (215, 248, '内江市', 'N');
INSERT INTO `cityCode` VALUES (216, 249, '曲靖市', 'Q');
INSERT INTO `cityCode` VALUES (217, 250, '淮南市', 'H');
INSERT INTO `cityCode` VALUES (218, 251, '巢湖市', 'C');
INSERT INTO `cityCode` VALUES (219, 252, '黄山市', 'H');
INSERT INTO `cityCode` VALUES (220, 253, '淮北市', 'H');
INSERT INTO `cityCode` VALUES (221, 254, '三明市', 'S');
INSERT INTO `cityCode` VALUES (222, 255, '漳州市', 'Z');
INSERT INTO `cityCode` VALUES (223, 256, '陇南市', 'L');
INSERT INTO `cityCode` VALUES (224, 257, '广州市', 'G');
INSERT INTO `cityCode` VALUES (225, 258, '云浮市', 'Y');
INSERT INTO `cityCode` VALUES (226, 259, '揭阳市', 'J');
INSERT INTO `cityCode` VALUES (227, 260, '贺州市', 'H');
INSERT INTO `cityCode` VALUES (228, 261, '南宁市', 'N');
INSERT INTO `cityCode` VALUES (229, 262, '遵义市', 'Z');
INSERT INTO `cityCode` VALUES (230, 263, '安顺市', 'A');
INSERT INTO `cityCode` VALUES (231, 264, '张家口市', 'Z');
INSERT INTO `cityCode` VALUES (232, 265, '唐山市', 'T');
INSERT INTO `cityCode` VALUES (233, 266, '邢台市', 'X');
INSERT INTO `cityCode` VALUES (234, 267, '安阳市', 'A');
INSERT INTO `cityCode` VALUES (235, 268, '郑州市', 'Z');
INSERT INTO `cityCode` VALUES (236, 269, '驻马店市', 'Z');
INSERT INTO `cityCode` VALUES (237, 270, '宜昌市', 'Y');
INSERT INTO `cityCode` VALUES (238, 271, '黄冈市', 'H');
INSERT INTO `cityCode` VALUES (239, 272, '益阳市', 'Y');
INSERT INTO `cityCode` VALUES (240, 273, '邵阳市', 'S');
INSERT INTO `cityCode` VALUES (241, 274, '湘西土家族苗族自治州', 'X');
INSERT INTO `cityCode` VALUES (242, 275, '郴州市', 'C');
INSERT INTO `cityCode` VALUES (243, 276, '泰州市', 'T');
INSERT INTO `cityCode` VALUES (244, 277, '宿迁市', 'S');
INSERT INTO `cityCode` VALUES (245, 278, '宜春市', 'Y');
INSERT INTO `cityCode` VALUES (246, 279, '鹰潭市', 'Y');
INSERT INTO `cityCode` VALUES (247, 280, '朝阳市', 'C');
INSERT INTO `cityCode` VALUES (248, 281, '营口市', 'Y');
INSERT INTO `cityCode` VALUES (249, 282, '丹东市', 'D');
INSERT INTO `cityCode` VALUES (250, 283, '鄂尔多斯市', 'E');
INSERT INTO `cityCode` VALUES (251, 284, '延安市', 'Y');
INSERT INTO `cityCode` VALUES (252, 285, '商洛市', 'S');
INSERT INTO `cityCode` VALUES (253, 286, '济宁市', 'J');
INSERT INTO `cityCode` VALUES (254, 287, '潍坊市', 'W');
INSERT INTO `cityCode` VALUES (255, 288, '济南市', 'J');
INSERT INTO `cityCode` VALUES (256, 289, '上海市', 'S');
INSERT INTO `cityCode` VALUES (257, 290, '晋城市', 'J');
INSERT INTO `cityCode` VALUES (258, 291, '南充市', 'N');
INSERT INTO `cityCode` VALUES (259, 292, '丽水市', 'L');
INSERT INTO `cityCode` VALUES (260, 293, '绍兴市', 'S');
INSERT INTO `cityCode` VALUES (261, 294, '湖州市', 'H');
INSERT INTO `cityCode` VALUES (262, 295, '北海市', 'B');
INSERT INTO `cityCode` VALUES (263, 297, '赤峰市', 'C');
INSERT INTO `cityCode` VALUES (264, 298, '六安市', 'L');
INSERT INTO `cityCode` VALUES (265, 299, '池州市', 'C');
INSERT INTO `cityCode` VALUES (266, 300, '福州市', 'F');
INSERT INTO `cityCode` VALUES (267, 301, '惠州市', 'H');
INSERT INTO `cityCode` VALUES (268, 302, '江门市', 'J');
INSERT INTO `cityCode` VALUES (269, 303, '汕头市', 'S');
INSERT INTO `cityCode` VALUES (270, 304, '梧州市', 'W');
INSERT INTO `cityCode` VALUES (271, 305, '柳州市', 'L');
INSERT INTO `cityCode` VALUES (272, 306, '黔南布依族苗族自治州', 'Q');
INSERT INTO `cityCode` VALUES (273, 307, '保定市', 'B');
INSERT INTO `cityCode` VALUES (274, 308, '周口市', 'Z');
INSERT INTO `cityCode` VALUES (275, 309, '南阳市', 'N');
INSERT INTO `cityCode` VALUES (276, 310, '孝感市', 'X');
INSERT INTO `cityCode` VALUES (277, 311, '黄石市', 'H');
INSERT INTO `cityCode` VALUES (278, 312, '张家界市', 'Z');
INSERT INTO `cityCode` VALUES (279, 313, '湘潭市', 'X');
INSERT INTO `cityCode` VALUES (280, 314, '永州市', 'Y');
INSERT INTO `cityCode` VALUES (281, 315, '南京市', 'N');
INSERT INTO `cityCode` VALUES (282, 316, '徐州市', 'X');
INSERT INTO `cityCode` VALUES (283, 317, '无锡市', 'W');
INSERT INTO `cityCode` VALUES (284, 318, '吉安市', 'J');
INSERT INTO `cityCode` VALUES (285, 319, '葫芦岛市', 'H');
INSERT INTO `cityCode` VALUES (286, 320, '鞍山市', 'A');
INSERT INTO `cityCode` VALUES (287, 321, '呼和浩特市', 'H');
INSERT INTO `cityCode` VALUES (288, 322, '吴忠市', 'W');
INSERT INTO `cityCode` VALUES (289, 323, '咸阳市', 'X');
INSERT INTO `cityCode` VALUES (290, 324, '安康市', 'A');
INSERT INTO `cityCode` VALUES (291, 325, '泰安市', 'T');
INSERT INTO `cityCode` VALUES (292, 326, '烟台市', 'Y');
INSERT INTO `cityCode` VALUES (293, 327, '吕梁市', 'L');
INSERT INTO `cityCode` VALUES (294, 328, '运城市', 'Y');
INSERT INTO `cityCode` VALUES (295, 329, '广元市', 'G');
INSERT INTO `cityCode` VALUES (296, 330, '遂宁市', 'S');
INSERT INTO `cityCode` VALUES (297, 331, '泸州市', NULL);
INSERT INTO `cityCode` VALUES (298, 332, '天津市', 'T');
INSERT INTO `cityCode` VALUES (299, 333, '金华市', 'J');
INSERT INTO `cityCode` VALUES (300, 334, '嘉兴市', 'J');
INSERT INTO `cityCode` VALUES (301, 335, '石嘴山市', 'S');
INSERT INTO `cityCode` VALUES (302, 336, '昭通市', 'Z');
INSERT INTO `cityCode` VALUES (303, 337, '铜陵市', 'T');
INSERT INTO `cityCode` VALUES (304, 338, '肇庆市', 'Z');
INSERT INTO `cityCode` VALUES (305, 339, '汕尾市', 'S');
INSERT INTO `cityCode` VALUES (306, 340, '深圳市', 'S');
INSERT INTO `cityCode` VALUES (307, 341, '贵港市', 'G');
INSERT INTO `cityCode` VALUES (308, 342, '黔东南苗族侗族自治州', 'Q');
INSERT INTO `cityCode` VALUES (309, 343, '黔西南布依族苗族自治州', 'Q');
INSERT INTO `cityCode` VALUES (310, 344, '漯河市', NULL);
INSERT INTO `cityCode` VALUES (311, 346, '扬州市', 'Y');
INSERT INTO `cityCode` VALUES (312, 347, '连云港市', 'L');
INSERT INTO `cityCode` VALUES (313, 348, '常州市', 'C');
INSERT INTO `cityCode` VALUES (314, 349, '九江市', 'J');
INSERT INTO `cityCode` VALUES (315, 350, '萍乡市', 'P');
INSERT INTO `cityCode` VALUES (316, 351, '辽阳市', 'L');
INSERT INTO `cityCode` VALUES (317, 352, '汉中市', 'H');
INSERT INTO `cityCode` VALUES (318, 353, '菏泽市', 'H');
INSERT INTO `cityCode` VALUES (319, 354, '淄博市', 'Z');
INSERT INTO `cityCode` VALUES (320, 355, '大同市', 'D');
INSERT INTO `cityCode` VALUES (321, 356, '长治市', 'C');
INSERT INTO `cityCode` VALUES (322, 357, '阳泉市', 'Y');
INSERT INTO `cityCode` VALUES (323, 358, '马鞍山市', 'M');
INSERT INTO `cityCode` VALUES (324, 359, '平凉市', 'P');
INSERT INTO `cityCode` VALUES (325, 360, '银川市', 'Y');
INSERT INTO `cityCode` VALUES (326, 361, '玉林市', 'Y');
INSERT INTO `cityCode` VALUES (327, 362, '咸宁市', 'X');
INSERT INTO `cityCode` VALUES (328, 363, '怀化市', 'H');
INSERT INTO `cityCode` VALUES (329, 364, '上饶市', 'S');
INSERT INTO `cityCode` VALUES (330, 365, '赣州市', 'G');
INSERT INTO `cityCode` VALUES (331, 366, '聊城市', 'L');
INSERT INTO `cityCode` VALUES (332, 367, '忻州市', 'X');
INSERT INTO `cityCode` VALUES (333, 368, '临汾市', 'L');
INSERT INTO `cityCode` VALUES (334, 369, '达州市', 'D');
INSERT INTO `cityCode` VALUES (335, 370, '宿州市', 'S');
INSERT INTO `cityCode` VALUES (336, 371, '随州市', 'S');
INSERT INTO `cityCode` VALUES (337, 372, '德州市', 'D');
INSERT INTO `cityCode` VALUES (338, 373, '恩施土家族苗族自治州', 'E');
INSERT INTO `cityCode` VALUES (339, 731, '阿拉尔市', 'A');
INSERT INTO `cityCode` VALUES (340, 770, '石河子市', 'S');
INSERT INTO `cityCode` VALUES (341, 789, '五家渠市', 'W');
INSERT INTO `cityCode` VALUES (342, 792, '图木舒克市', 'T');
INSERT INTO `cityCode` VALUES (343, 1214, '定安县', 'D');
INSERT INTO `cityCode` VALUES (344, 1215, '儋州市', NULL);
INSERT INTO `cityCode` VALUES (345, 1216, '万宁市', 'W');
INSERT INTO `cityCode` VALUES (346, 1217, '保亭黎族苗族自治县', 'B');
INSERT INTO `cityCode` VALUES (347, 1218, '西沙群岛', 'X');
INSERT INTO `cityCode` VALUES (348, 1277, '济源市', 'J');
INSERT INTO `cityCode` VALUES (349, 1293, '潜江市', 'Q');
INSERT INTO `cityCode` VALUES (350, 1498, '中沙群岛', 'Z');
INSERT INTO `cityCode` VALUES (351, 1515, '南沙群岛', 'N');
INSERT INTO `cityCode` VALUES (352, 1641, '屯昌县', 'T');
INSERT INTO `cityCode` VALUES (353, 1642, '昌江黎族自治县', 'C');
INSERT INTO `cityCode` VALUES (354, 1643, '陵水黎族自治县', 'L');
INSERT INTO `cityCode` VALUES (355, 1644, '五指山市', 'W');
INSERT INTO `cityCode` VALUES (356, 1713, '仙桃市', 'X');
INSERT INTO `cityCode` VALUES (357, 2031, '琼中黎族苗族自治县', 'Q');
INSERT INTO `cityCode` VALUES (358, 2032, '乐东黎族自治县', 'L');
INSERT INTO `cityCode` VALUES (359, 2033, '临高县', 'L');
INSERT INTO `cityCode` VALUES (360, 2358, '琼海市', 'Q');
INSERT INTO `cityCode` VALUES (361, 2359, '白沙黎族自治县', 'B');
INSERT INTO `cityCode` VALUES (362, 2634, '东方市', 'D');
INSERT INTO `cityCode` VALUES (363, 2654, '天门市', 'T');
INSERT INTO `cityCode` VALUES (364, 2734, '神农架林区', 'S');
INSERT INTO `cityCode` VALUES (365, 2757, '澄迈县', 'C');
INSERT INTO `cityCode` VALUES (366, 2758, '文昌市', 'W');
INSERT INTO `cityCode` VALUES (367, 2911, '澳门特别行政区', 'A');
INSERT INTO `cityCode` VALUES (368, 2912, '香港特别行政区', 'X');
INSERT INTO `cityCode` VALUES (369, 9001, '桃园市', 'T');
INSERT INTO `cityCode` VALUES (370, 9002, '台北市', 'T');
INSERT INTO `cityCode` VALUES (371, 9003, '南投县', 'N');
INSERT INTO `cityCode` VALUES (372, 9004, '嘉义市', 'J');
INSERT INTO `cityCode` VALUES (373, 9005, '彰化县', 'Z');
INSERT INTO `cityCode` VALUES (374, 9006, '新竹县', 'X');
INSERT INTO `cityCode` VALUES (375, 9007, '澎湖县', 'P');
INSERT INTO `cityCode` VALUES (376, 9008, '台东县', 'T');
INSERT INTO `cityCode` VALUES (377, 9009, '宜兰县', 'Y');
INSERT INTO `cityCode` VALUES (378, 9010, '新北市', 'X');
INSERT INTO `cityCode` VALUES (379, 9011, '基隆市', 'J');
INSERT INTO `cityCode` VALUES (380, 9012, '屏东县', 'P');
INSERT INTO `cityCode` VALUES (381, 9013, '嘉义县', 'J');
INSERT INTO `cityCode` VALUES (382, 9014, '云林县', 'Y');
INSERT INTO `cityCode` VALUES (383, 9015, '花莲县', 'H');
INSERT INTO `cityCode` VALUES (384, 9016, '台南市', 'T');
INSERT INTO `cityCode` VALUES (385, 9017, '台中市', 'T');
INSERT INTO `cityCode` VALUES (386, 9018, '新竹市', 'X');
INSERT INTO `cityCode` VALUES (387, 9019, '高雄市', 'G');
INSERT INTO `cityCode` VALUES (388, 9020, '苗栗县', 'M');
COMMIT;

-- ----------------------------
-- Table structure for CubeLibraryProfit
-- ----------------------------
DROP TABLE IF EXISTS `CubeLibraryProfit`;
CREATE TABLE `CubeLibraryProfit` (
  `AutoNumber` int(11) NOT NULL COMMENT '自动编号',
  `LicensePlateNumber` varchar(32) NOT NULL COMMENT '车牌号',
  `ChargeTime` datetime NOT NULL COMMENT '收费时间',
  `ParkingDuration` decimal(12,2) NOT NULL COMMENT '停车时长',
  `UnitPriceOfCharges` decimal(12,2) NOT NULL COMMENT '收费单价',
  `MemberDiscount` decimal(12,2) NOT NULL COMMENT '会员优惠',
  `ChargeAmount` decimal(12,2) NOT NULL COMMENT '收费金额',
  PRIMARY KEY (`AutoNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='立方库营利';

-- ----------------------------
-- Table structure for DetailsOfCharges
-- ----------------------------
DROP TABLE IF EXISTS `DetailsOfCharges`;
CREATE TABLE `DetailsOfCharges` (
  `Member` int(11) NOT NULL COMMENT '会员等级',
  `Price` float NOT NULL COMMENT '价格',
  `WaitFor` int(11) NOT NULL COMMENT '等待时间',
  `BookingFee` float NOT NULL COMMENT '预约费用',
  PRIMARY KEY (`Member`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='会员等级收费明细';

-- ----------------------------
-- Records of DetailsOfCharges
-- ----------------------------
BEGIN;
INSERT INTO `DetailsOfCharges` VALUES (0, 12, 15, 8);
INSERT INTO `DetailsOfCharges` VALUES (1, 11, 20, 0);
INSERT INTO `DetailsOfCharges` VALUES (2, 10, 25, 0);
INSERT INTO `DetailsOfCharges` VALUES (3, 10, 35, 0);
INSERT INTO `DetailsOfCharges` VALUES (4, 9, 40, 0);
INSERT INTO `DetailsOfCharges` VALUES (5, 8, 40, 0);
INSERT INTO `DetailsOfCharges` VALUES (6, 7, 40, 0);
INSERT INTO `DetailsOfCharges` VALUES (7, 6, 45, 0);
COMMIT;

-- ----------------------------
-- Table structure for j_user_tokens
-- ----------------------------
DROP TABLE IF EXISTS `j_user_tokens`;
CREATE TABLE `j_user_tokens` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(32) NOT NULL,
  `token` varchar(40) NOT NULL,
  `logintime` datetime NOT NULL,
  `expires` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `token` (`token`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='自动登录代理';

-- ----------------------------
-- Records of j_user_tokens
-- ----------------------------
BEGIN;
INSERT INTO `j_user_tokens` VALUES (1, 'NTExNTIxMTk5ODA3MDc2MTcx', '0563a70058a4bc732f2e2d06e4a6aa33', '2019-11-14 03:48:44', 3);
INSERT INTO `j_user_tokens` VALUES (2, 'NTAwMTAzMTk5OTAyMjM1OTEx', '8e7e528a09c6722e2df285b813b3206c', '2019-11-04 04:13:33', 3);
COMMIT;

-- ----------------------------
-- Table structure for LdleParking
-- ----------------------------
DROP TABLE IF EXISTS `LdleParking`;
CREATE TABLE `LdleParking` (
  `AutoNumber` int(11) NOT NULL AUTO_INCREMENT COMMENT '自动编号',
  `CubeLibraryNumber` varchar(32) NOT NULL COMMENT '立方库编号',
  `Region` char(1) NOT NULL COMMENT '区域',
  `Arrangement` int(11) NOT NULL COMMENT '层次',
  `Number` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '编号',
  PRIMARY KEY (`AutoNumber`)
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='空闲车位';

-- ----------------------------
-- Records of LdleParking
-- ----------------------------
BEGIN;
INSERT INTO `LdleParking` VALUES (1, '75-0', 'A', 1, '[2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,1]');
INSERT INTO `LdleParking` VALUES (2, '75-0', 'A', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (3, '75-0', 'A', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (4, '75-0', 'A', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (5, '75-0', 'A', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (6, '75-0', 'B', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (7, '75-0', 'B', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (8, '75-0', 'B', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (9, '75-0', 'B', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (10, '75-0', 'B', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (11, '75-0', 'C', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (12, '75-0', 'C', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (13, '75-0', 'C', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (14, '75-0', 'C', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (15, '75-0', 'C', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (16, '75-0', 'D', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (17, '75-0', 'D', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (18, '75-0', 'D', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (19, '75-0', 'D', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (20, '75-0', 'D', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (21, '75-1', 'A', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (22, '75-1', 'A', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (23, '75-1', 'A', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (24, '75-1', 'A', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (25, '75-1', 'A', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (26, '75-1', 'B', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (27, '75-1', 'B', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (28, '75-1', 'B', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (29, '75-1', 'B', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (30, '75-1', 'B', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (31, '75-1', 'C', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (32, '75-1', 'C', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (33, '75-1', 'C', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (34, '75-1', 'C', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (35, '75-1', 'C', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (36, '75-1', 'D', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (37, '75-1', 'D', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (38, '75-1', 'D', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (39, '75-1', 'D', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (40, '75-1', 'D', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (41, '75-2', 'A', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (42, '75-2', 'A', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (43, '75-2', 'A', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (44, '75-2', 'A', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (45, '75-2', 'A', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (46, '75-2', 'B', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (47, '75-2', 'B', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (48, '75-2', 'B', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (49, '75-2', 'B', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (50, '75-2', 'B', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (51, '75-2', 'C', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (52, '75-2', 'C', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (53, '75-2', 'C', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (54, '75-2', 'C', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (55, '75-2', 'C', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (56, '75-2', 'D', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (57, '75-2', 'D', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (58, '75-2', 'D', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (59, '75-2', 'D', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (60, '75-2', 'D', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (61, '75-3', 'A', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (62, '75-3', 'A', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (63, '75-3', 'A', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (64, '75-3', 'A', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (65, '75-3', 'A', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (66, '75-3', 'B', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (67, '75-3', 'B', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (68, '75-3', 'B', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (69, '75-3', 'B', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (70, '75-3', 'B', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (71, '75-3', 'C', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (72, '75-3', 'C', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (73, '75-3', 'C', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (74, '75-3', 'C', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (75, '75-3', 'C', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (76, '75-3', 'D', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (77, '75-3', 'D', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (78, '75-3', 'D', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (79, '75-3', 'D', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (80, '75-3', 'D', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (81, '75-4', 'A', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (82, '75-4', 'A', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (83, '75-4', 'A', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (84, '75-4', 'A', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (85, '75-4', 'A', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (86, '75-4', 'B', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (87, '75-4', 'B', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (88, '75-4', 'B', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (89, '75-4', 'B', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (90, '75-4', 'B', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (91, '75-4', 'C', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (92, '75-4', 'C', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (93, '75-4', 'C', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (94, '75-4', 'C', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (95, '75-4', 'C', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (96, '75-4', 'D', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (97, '75-4', 'D', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (98, '75-4', 'D', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (99, '75-4', 'D', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (100, '75-4', 'D', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (101, '75-5', 'A', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (102, '75-5', 'A', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (103, '75-5', 'A', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (104, '75-5', 'A', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (105, '75-5', 'A', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (106, '75-5', 'B', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (107, '75-5', 'B', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (108, '75-5', 'B', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (109, '75-5', 'B', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (110, '75-5', 'B', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (111, '75-5', 'C', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (112, '75-5', 'C', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (113, '75-5', 'C', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (114, '75-5', 'C', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (115, '75-5', 'C', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (116, '75-5', 'D', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (117, '75-5', 'D', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (118, '75-5', 'D', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (119, '75-5', 'D', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (120, '75-5', 'D', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (121, '75-6', 'A', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (122, '75-6', 'A', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (123, '75-6', 'A', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (124, '75-6', 'A', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (125, '75-6', 'A', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (126, '75-6', 'B', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (127, '75-6', 'B', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (128, '75-6', 'B', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (129, '75-6', 'B', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (130, '75-6', 'B', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (131, '75-6', 'C', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (132, '75-6', 'C', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (133, '75-6', 'C', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (134, '75-6', 'C', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (135, '75-6', 'C', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (136, '75-6', 'D', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (137, '75-6', 'D', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (138, '75-6', 'D', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (139, '75-6', 'D', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (140, '75-6', 'D', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (141, '75-7', 'A', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (142, '75-7', 'A', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (143, '75-7', 'A', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (144, '75-7', 'A', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (145, '75-7', 'A', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (146, '75-7', 'B', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (147, '75-7', 'B', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (148, '75-7', 'B', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (149, '75-7', 'B', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (150, '75-7', 'B', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (151, '75-7', 'C', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (152, '75-7', 'C', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (153, '75-7', 'C', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (154, '75-7', 'C', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (155, '75-7', 'C', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (156, '75-7', 'D', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (157, '75-7', 'D', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (158, '75-7', 'D', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (159, '75-7', 'D', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (160, '75-7', 'D', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (161, '75-8', 'A', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (162, '75-8', 'A', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (163, '75-8', 'A', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (164, '75-8', 'A', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (165, '75-8', 'A', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (166, '75-8', 'B', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (167, '75-8', 'B', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (168, '75-8', 'B', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (169, '75-8', 'B', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (170, '75-8', 'B', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (171, '75-8', 'C', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (172, '75-8', 'C', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (173, '75-8', 'C', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (174, '75-8', 'C', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (175, '75-8', 'C', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (176, '75-8', 'D', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (177, '75-8', 'D', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (178, '75-8', 'D', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (179, '75-8', 'D', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (180, '75-8', 'D', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (181, '75-9', 'A', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (182, '75-9', 'A', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (183, '75-9', 'A', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (184, '75-9', 'A', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (185, '75-9', 'A', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (186, '75-9', 'B', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (187, '75-9', 'B', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (188, '75-9', 'B', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (189, '75-9', 'B', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (190, '75-9', 'B', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (191, '75-9', 'C', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (192, '75-9', 'C', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (193, '75-9', 'C', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (194, '75-9', 'C', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (195, '75-9', 'C', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (196, '75-9', 'D', 1, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (197, '75-9', 'D', 2, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (198, '75-9', 'D', 3, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (199, '75-9', 'D', 4, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
INSERT INTO `LdleParking` VALUES (200, '75-9', 'D', 5, '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]');
COMMIT;

-- ----------------------------
-- Table structure for MemberPayRecore
-- ----------------------------
DROP TABLE IF EXISTS `MemberPayRecore`;
CREATE TABLE `MemberPayRecore` (
  `IDNumber` varchar(18) NOT NULL COMMENT '身份证号',
  `OpenTime` datetime NOT NULL COMMENT '开通时间',
  `OpenMonth` int(11) NOT NULL COMMENT '开通月数',
  `ShouldMoney` float(6,2) NOT NULL COMMENT '应付金额',
  `ActuleMoney` float(6,2) NOT NULL COMMENT '实付金额',
  `IsSession` bit(1) NOT NULL COMMENT '是否在期',
  PRIMARY KEY (`IDNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='会员充值记录';

-- ----------------------------
-- Records of MemberPayRecore
-- ----------------------------
BEGIN;
INSERT INTO `MemberPayRecore` VALUES ('511521199807076171', '2019-11-01 16:45:22', 3, 60.00, 60.00, b'0');
COMMIT;

-- ----------------------------
-- Table structure for MemberSetMeal
-- ----------------------------
DROP TABLE IF EXISTS `MemberSetMeal`;
CREATE TABLE `MemberSetMeal` (
  `AutoNumber` int(6) NOT NULL AUTO_INCREMENT COMMENT '自动编号',
  `OpenTime` int(6) NOT NULL COMMENT '开多久会员（月）',
  `Money` decimal(6,2) NOT NULL COMMENT '金额',
  `Value` varchar(10) DEFAULT NULL COMMENT '价值',
  `OriginalPrice` int(6) DEFAULT NULL COMMENT '原价',
  PRIMARY KEY (`AutoNumber`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='会员套餐';

-- ----------------------------
-- Records of MemberSetMeal
-- ----------------------------
BEGIN;
INSERT INTO `MemberSetMeal` VALUES (1, 1, 25.00, '普通', 30);
INSERT INTO `MemberSetMeal` VALUES (2, 3, 60.00, '优惠', 90);
INSERT INTO `MemberSetMeal` VALUES (3, 6, 118.00, '超值', 180);
INSERT INTO `MemberSetMeal` VALUES (4, 12, 238.00, '精品', 360);
COMMIT;

-- ----------------------------
-- Table structure for MembershipInformation
-- ----------------------------
DROP TABLE IF EXISTS `MembershipInformation`;
CREATE TABLE `MembershipInformation` (
  `AutoNumber` int(11) NOT NULL AUTO_INCREMENT COMMENT '自动编号',
  `Name` varchar(32) NOT NULL COMMENT '姓名',
  `IDNumber` varchar(18) NOT NULL COMMENT '身份证号',
  `LicensePlateNumber` varchar(32) NOT NULL COMMENT '车牌号',
  `CellPhoneNumber` varchar(11) NOT NULL COMMENT '手机号',
  `RegisterTime` datetime NOT NULL COMMENT '注册时间',
  `Member` varchar(1) NOT NULL DEFAULT '0' COMMENT '会员',
  `Grade` int(11) NOT NULL DEFAULT '0' COMMENT '等级',
  `Balance` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '优惠',
  `Password` varchar(32) NOT NULL COMMENT '密码',
  `Stal` varchar(32) NOT NULL COMMENT '盐',
  PRIMARY KEY (`AutoNumber`),
  KEY `membershipinformation_ibfk_1` (`IDNumber`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='会员信息';

-- ----------------------------
-- Records of MembershipInformation
-- ----------------------------
BEGIN;
INSERT INTO `MembershipInformation` VALUES (1, '张健强', '511521199807076171', '京ALJ183,甘E66666,甘A88888', '17345252917', '2019-10-17 13:49:15', '0', 1, 0.00, 'acb94e83c78d8654cd8b043970f66863', 'QCVuQ8vXvy');
INSERT INTO `MembershipInformation` VALUES (2, '王彦钧', '500103199902235911', '京A66666', '18081456625', '2019-10-17 14:19:07', '0', 0, 0.00, '8c08523edc522307898870b0470b3554', '733dy6VJ6h');
COMMIT;

-- ----------------------------
-- Table structure for NationalTreasury
-- ----------------------------
DROP TABLE IF EXISTS `NationalTreasury`;
CREATE TABLE `NationalTreasury` (
  `AutoNumber` int(11) NOT NULL AUTO_INCREMENT COMMENT '自动编号',
  `CityCode` int(12) NOT NULL COMMENT '城市代码',
  `CubeLibraryNumber` varchar(32) DEFAULT NULL COMMENT '立方库编号',
  `CubeLibraryAddress` varchar(100) DEFAULT NULL COMMENT '立方库地址',
  PRIMARY KEY (`AutoNumber`),
  KEY `nationaltreasury_ibfk_1` (`CityCode`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='全国库';

-- ----------------------------
-- Records of NationalTreasury
-- ----------------------------
BEGIN;
INSERT INTO `NationalTreasury` VALUES (1, 75, '75-0', '成都市203号');
INSERT INTO `NationalTreasury` VALUES (2, 75, '75-1', '成都市204号');
INSERT INTO `NationalTreasury` VALUES (3, 75, '75-2', '成都市205号');
INSERT INTO `NationalTreasury` VALUES (4, 75, '75-3', '成都市206号');
INSERT INTO `NationalTreasury` VALUES (5, 75, '75-4', '成都市207号');
INSERT INTO `NationalTreasury` VALUES (6, 75, '75-5', '成都市208号');
INSERT INTO `NationalTreasury` VALUES (7, 75, '75-6', '成都市209号');
INSERT INTO `NationalTreasury` VALUES (8, 75, '75-7', '成都市210号');
INSERT INTO `NationalTreasury` VALUES (9, 75, '75-8', '成都市211号');
INSERT INTO `NationalTreasury` VALUES (10, 75, '75-9', '成都市212号');
INSERT INTO `NationalTreasury` VALUES (11, 186, '186-0', '宜宾市203号');
INSERT INTO `NationalTreasury` VALUES (12, 186, '186-1', '宜宾市204号');
INSERT INTO `NationalTreasury` VALUES (13, 186, '186-2', '宜宾市205号');
INSERT INTO `NationalTreasury` VALUES (14, 186, '186-3', '宜宾市206号');
INSERT INTO `NationalTreasury` VALUES (15, 186, '186-4', '宜宾市207号');
INSERT INTO `NationalTreasury` VALUES (16, 186, '186-5', '宜宾市208号');
INSERT INTO `NationalTreasury` VALUES (17, 186, '186-6', '宜宾市209号');
INSERT INTO `NationalTreasury` VALUES (18, 186, '186-7', '宜宾市210号');
INSERT INTO `NationalTreasury` VALUES (19, 186, '186-8', '宜宾市211号');
INSERT INTO `NationalTreasury` VALUES (20, 186, '186-9', '宜宾市212号');
INSERT INTO `NationalTreasury` VALUES (21, 329, '329-0', '广元市203号');
INSERT INTO `NationalTreasury` VALUES (22, 329, '329-1', '广元市204号');
INSERT INTO `NationalTreasury` VALUES (23, 329, '329-2', '广元市205号');
INSERT INTO `NationalTreasury` VALUES (24, 329, '329-3', '广元市206号');
INSERT INTO `NationalTreasury` VALUES (25, 329, '329-4', '广元市207号');
INSERT INTO `NationalTreasury` VALUES (26, 329, '329-5', '广元市208号');
INSERT INTO `NationalTreasury` VALUES (27, 329, '329-6', '广元市209号');
INSERT INTO `NationalTreasury` VALUES (28, 329, '329-7', '广元市210号');
INSERT INTO `NationalTreasury` VALUES (29, 329, '329-8', '广元市211号');
INSERT INTO `NationalTreasury` VALUES (30, 329, '329-9', '广元市212号');
COMMIT;

-- ----------------------------
-- Table structure for ParkingInformation
-- ----------------------------
DROP TABLE IF EXISTS `ParkingInformation`;
CREATE TABLE `ParkingInformation` (
  `LicensePlateNumber` varchar(32) NOT NULL COMMENT '车牌号',
  `CubeLibraryNumber` varchar(32) NOT NULL COMMENT '立方库编号',
  `Region` char(1) NOT NULL COMMENT '区域',
  `Arrangement` int(11) NOT NULL COMMENT '层次',
  `Number` int(11) NOT NULL COMMENT '编号',
  PRIMARY KEY (`LicensePlateNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='车位信息';

-- ----------------------------
-- Table structure for VehicleAccessInformation
-- ----------------------------
DROP TABLE IF EXISTS `VehicleAccessInformation`;
CREATE TABLE `VehicleAccessInformation` (
  `AutoNumber` int(11) NOT NULL AUTO_INCREMENT COMMENT '自动编号',
  `Name` varchar(32) NOT NULL COMMENT '姓名',
  `IDNumber` varchar(18) NOT NULL COMMENT '身份证号',
  `LicensePlateNumber` varchar(32) NOT NULL COMMENT '车牌号',
  `PickUpCode` varchar(32) NOT NULL COMMENT '取车码',
  `MembershipLevel` int(11) NOT NULL COMMENT '会员等级',
  `MembershipDiscount` decimal(12,2) NOT NULL COMMENT '会员优惠',
  `WarehousingTime` datetime NOT NULL COMMENT '入库时间',
  `OutgoingTime` datetime DEFAULT NULL COMMENT '出库时间',
  `BookingParking` varchar(32) NOT NULL COMMENT '车位号',
  PRIMARY KEY (`AutoNumber`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='车辆出入信息';

-- ----------------------------
-- Records of VehicleAccessInformation
-- ----------------------------
BEGIN;
INSERT INTO `VehicleAccessInformation` VALUES (56, '张健强', '511521199807076171', '京ALJ183', '48352', 1, 0.00, '2019-11-14 05:57:53', '2019-11-14 05:58:01', '75-0-A-1-1');
INSERT INTO `VehicleAccessInformation` VALUES (57, '张健强', '511521199807076171', '甘E66666', '85330', 1, 0.00, '2019-11-14 05:58:54', '2019-11-14 05:59:07', '75-0-A-1-1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
